package manager.goods;

import common.db.*;
import common.main.*;

public class GoodsInfoBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String gcode = (String)inputTable.get("gcode");

		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT ");
		queryBuffer.append("GCODE, GNAME, PURCHARSE_WAY, "); 
		queryBuffer.append("STOCK_VALUE, COST, GOODS_PRICE, "); 
		queryBuffer.append("SAVING_POINT, TO_CHAR(MK_DATE, 'YYYY-MM-DD') MK_DATE, EX_DATE, "); 
		queryBuffer.append("TO_CHAR(SE_DATE, 'YYYY-MM-DD') SE_DATE, TE_DATE, SELL_CNT, "); 
		queryBuffer.append("REG_ID, TO_CHAR(REG_DATE, 'YYYY-MM-DD') REG_DATE, REG_IP, "); 
		queryBuffer.append("UPD_ID, TO_CHAR(UPD_DATE, 'YYYY-MM-DD') UPD_DATE, UPD_IP, ");  
		queryBuffer.append("USE_YN ");
		queryBuffer.append("FROM GOODS WHERE GCODE='" + gcode+"'");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}